Store (In Database)
(In-Database Processing)
Synopsis
Stores the input data in the database.Description
This operator writes the input data into the database. Note that this operator requires proper CREATE TABLE privileges in the selected schema. No data is retrieved to the memory of the machine running this process unless the output of this operator is connected to a Nest output. This way, you can implement ETL processes without worrying about running out of memory, since the entire process will be pushed into the database.
Input
example set input
Output
- example set output
Parameters
- schema name Name of the schema.
- table name Output table.
- overwrite modeThis parameter indicates if an existing table should be overwritten or data should be appended to the existing data.